# Lookup example

The following example shows how a lookup table is used to concatenate a Dutch translation of the category name (located in the lookup table) to the original category name located in the landing table.

The lookup could be defined using the following expressions:

1. Condition expression: `${Lookup.CategoryID}=${Landing.CategoryID}`

   Meaning: Perform the lookup only if the Category ID in the landing table and the lookup table are the same.

2. Result column expression: `${Lookup.CategoryName} + ’is’ + ${Landing.CategoryName}`

   Meaning: Add the data in the CategoryName column in the lookup table to the data in the CategoryName column in the landing table (separated by the word "is").

Example:

Assuming the result column name is "Split Name", clicking the Preview Results button would display the following table:

Example table output

| Split Name | Category Name (Lookup) | Category Name (Landing) | Category ID (Lookup) | Category ID (Landing) |
| --- | --- | --- | --- | --- |
| dranken is Beverages | dranken | Beverages | 1 | 1 |
| Specerijen is Condiments | Specerijen | Condiments | 2 | 2 |
| Gebak is Confectionary | Gebak | Confectionary | 3 | 3 |
| Zuivelproducten is Dairy Products | Zuivelproducten | Dairy Products | 4 | 4 |
| Grains/Granen is Grains/Cereal | Grains/Granen | Grains/Cereal | 5 | 5 |
| Vlees/Gevolgete is Meat/Poultry | Vlees/Gevolgete | Meat/Poultry | 6 | 6 |